2013-03-21 -4678.400-Rel Notes - ROC rework implementation - Update User IDs in ROCET with ROC IDs #DotNetReleases2013

Release Notes

2013-03-21-4678.400-ROC rework implementation - Update User IDs in ROCET with ROC IDs

Admin Info

Purpose
 Update UserIDs in ROCET with ROC IDs
Release No#
 001
Submitted on
 03/21/2013
Submitted by
 Rajesh K
Source/Destination Systems
 NEC DEV/NEC QA
Release Sent To
 Bibin
Objects Created By
 Rajesh K
Objects Tested By
 Rajesh K

Transport and Technical Objects

Location Objects Name
\\neccgwebdev\sites\Deployments\BMS ROCET RELEASES\03212013_SQL
  • ROC Users Migration Script Prod.sql

Release Notes

For Infrastructure


Please take backup of tblUserMst from ROCET Database.

Execute ROC Users Migration Script Prod.sql on ROCET database.

For Requestor


Test Notes

Title
Module
Steps
Expected Result
1) Compare Rows
 DB Users Comparision
  1. Login to production DB
  2. Select ROC Users from tblUserMst with ADID,User_MST_ID columns
  3. Select ROCET Users from tblUserMst with ADID,User_MST_ID columns
  4. Compare the list and map on ADID
  1. Logs to production SQL
  2. returns all users in ROC.
  3. returns all users in ROCET.
  4. User User_MST_ID should match for all ADID in roc

Reference Document (Specifications or Production Support Break Fix)

2013-03-21- 4678.400 -Spec-ROC rework implementation - Update User IDs in ROCET with ROC IDs